Towards a Matrix Based Approach for Analyzing the Impact of Change on ETL Processes
نویسندگان
چکیده
Extraction, Transformation and Loading (ETL) processes aim to extract data from data sources to targets, via a set of transformations. In many situations, an ETL process can be subject to changes for several reasons. For instance, data sources changes, new requirements and bug fixing. When changes happen, analyzing the impact of change is mandatory to avoid errors and mitigate the risk of breaking existent treatments. Several solutions have been proposed for this issue. We propose a new approach, based on matrices, for analyzing the impact of change on ETL processes. The goal of this paper is to present the theoretical fundament of our approach. We model ETL parts as matrices then we propose an algorithm which detects the affected parts in an ETL process, given an attribute deletion event. Compared with the existent solutions, our approach has the advantage of easiness.
منابع مشابه
Analyzing the impact of university on regional development in Iran
The purpose of this paper was to analyze the impact of the university on regional development in Iran in the theoretical framework of the knowledge-based development ecosystem. This research was conducted with a descriptive approach, which is a practical and quantitative method. For the empirical analysis of ecosystem of the knowledge-based development and university assistance for regional dev...
متن کاملA risk model for cloud processes
Traditionally, risk assessment consists of evaluating the probability of "feared events", corresponding to known threats and attacks, as well as these events' severity, corresponding to their impact on one or more stakeholders. Assessing risks of cloud-based processes is particularly difficult due to lack of historical data on attacks, which has prevented frequency-based identification...
متن کاملA Fuzzy ANP-SWOT Approach for Analyzing the IT Problems Based on Capabilities in Iran
Determining strategy, as a very effective tool for policy (and especially science and technology policy), helps governments to be able in the challenges such as globalization and increased competition, and have an appropriate respond in the world today. Although some scattered researches about strategy determining have been conducted in Iran, the purpose of them is to recognize the future of IT...
متن کاملChanges in wheat production technology and the impact on the rural economy in Fars Province
Introduction The increasing population growth and the need for more agricultural products on the one hand, and on the other hand, the limitations of agricultural development are problems that human beings have always tried to solve. Due to the limited resources and inputs of production, it seems that further production growth is possible through advanced technologies. In fact, technology is so...
متن کاملMoving Towards Accountability for Reasonableness – A Systematic Exploration of the Features of Legitimate Healthcare Coverage Decision-Making Processes Using Rare Diseases and Regenerative Therapies as a Case Study
Background The accountability for reasonableness (A4R) framework defines 4 conditions for legitimate healthcare coverage decision processes: Relevance, Publicity, Appeals, and Enforcement. The aim of this study was to reflect on how the diverse features of decision-making processes can be aligned with A4R conditions to guide decisio...
متن کامل